Configuring Data Warehouse Permissions

For an AssetWise user to use the data warehouse the "Can Use OData" permission needs to be configured for that user.

Follow these steps to configure data warehouse user permissions.

In AssetWise Director, open System Administration, and navigate to the Security section.
Create a new role in AssetWise.
In the Permissions, System Information section, apply the Can Use OData permission to the role.
Add all the users whom are allowed to access the warehouse.

The following configuration can only be done at the database level by the system administration or Bentley professional services. A table resides in the database called perm_odata_roles. Refer to the document B00091717 "Technical Specification - Standard Search and Data Extraction Endpoint " for detailed information and population scripts. This table stores information of which permission role in AssetWise can access a given entity (table or view) as configured in the data warehouse setup. The table definition is as follows:

role_id - The role_id of the configured permission role
warehouse_name - The name of the configured warehouse, in this document Demo was used
entity - The name of a database table or view as selected earlies in this document

This enables multiple different permission exposure for a single warehouse name. For example,

role_id	warehouse_name	entity
1	Demo	DocumentView
1	Demo	AttributeView
2	Demo	TagView

In the above table, there are two configured permission roles configured for the same data warehouse. Persons who belong to role_id "1" are only have access to view information exposed by the entities: "DocumentView" and "AttributeView". Persons belonging to role_id "2" are only be able to access information exposed by the entity "TagView". Note that this table must be populated manually, as there is no current user interface for this configuration.